home *** CD-ROM | disk | FTP | other *** search
/ Agent Central Host Computer / Agent - Central Host Computer.iso / _SETUP.1 / wayvalpass.sql < prev    next >
Text File  |  2000-05-12  |  1KB  |  43 lines
  1. /* RCSVER $Id: wayvalpass.sql,v 1.2 1999-06-03 14:37:26-05 evan CURRENT $ */
  2. /* *************************************************************************
  3. *        Copyright (C) 1999, Agent Systems, Inc. All Rights Reserved.
  4. *
  5. * Name:        wayvalpass.sql
  6. * Date:        05/24/1999
  7. * memo:        Randy Wood
  8. * Description:    Create the wayvalpass table. This table contains probed data
  9. *        from the WAYFARER_VALIDATED_PASS_RECORD.
  10. * Changes:
  11. ************************************************************************* */
  12. CREATE TABLE wayvalpass
  13. (
  14.     det_seq_num    NUMBER(38)
  15.         CONSTRAINT ref_wayvalpass REFERENCES mstrrec(det_seq_num),
  16.     farebox_glid    NUMBER(38),
  17.     conv_date    DATE,
  18.     descriptor     NUMBER(38),
  19.     dvariable    NUMBER(38),
  20.     process_type    NUMBER(38),
  21.     startday    NUMBER(38),
  22.     startmo        NUMBER(38),
  23.     startyr        NUMBER(38),
  24.     expday        NUMBER(38),
  25.     expmo        NUMBER(38),
  26.     expyr        NUMBER(38),
  27.     card_id        NUMBER(38),
  28.     pos_id        NUMBER(38),
  29.     card_rte    NUMBER(38),
  30.     journday    NUMBER(38),
  31.     boardday    NUMBER(38),
  32.     boardmo        NUMBER(38),
  33.     boardyr        NUMBER(38),
  34.     boardhr        NUMBER(38),
  35.     boardmin    NUMBER(38),
  36.     boardrte    NUMBER(38),
  37.     xfernum        NUMBER(38),
  38.     xferrte        NUMBER(38),
  39.     prevrte        NUMBER(38),
  40.     radix        VARCHAR2(12),
  41.         CONSTRAINT pk_wayvalpass PRIMARY KEY (det_seq_num)
  42. );
  43.